package org.jeecg.modules.submodules.mapper;

import org.apache.ibatis.annotations.Select;
import org.jeecg.modules.submodules.entity.Goods;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @Description: 货物
 * @Author: jeecg-boot
 * @Date:   2020-07-07
 * @Version: V1.0
 */
@Repository
public interface GoodsMapper extends BaseMapper<Goods> {
    @Select("SELECT\n" +
            "\tid,\n" +
            "\tgoods_name,\n" +
            "\tgoods_price,\n" +
            "\tcreated_by,\n" +
            "\tcreated_time,\n" +
            "\tupdated_by,\n" +
            "\tupdated_time \n" +
            "FROM\n" +
            "\tgoods \n" +
            "ORDER BY\n" +
            "\tCONVERT ( GOODS_NAME USING gbk ) ASC;")
    List<Goods> getGoodsList();
}
